﻿CREATE PROCEDURE [vantage].[s_Admin_CreateObjects] AS

EXEC vantage.s_Admin_CreateObjects_10
EXEC vantage.s_Admin_CreateObjects_20
EXEC vantageExport.s_ALL

DECLARE @SQL varchar(8000)
SET @SQL = '
SELECT ''vantage.Notes'' Notes,  MAX(CreatedDate) AS CreatedDate FROM vantage.t_Note
SELECT ''dbo.Notes'' Notes,  MAX(NoteDate) NoteDate FROM t_Note
'
EXEC admin.s_Mail_System '[vantage].[s_Admin_CreateObjects]','',@SQL

